Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL
1) Aggregate Functions
2) Analytical Functions
3) Constraints
4) Cursor
5) Data Set
6) Data Type
7) Database
8) Date Timezone
9) Index
10) Insert Delete Update
11) Math Functions
12) Select Query
13) Sequence
14) Store Procedure Function
15) String Functions
16) Subquery
17) System
18) Table
19) Table Joins
20) Transact SQL
21) Transaction
22) Trigger
23) View
24) XML

Subquery
1) A subquery can be used with comparison operators
2) A subquery is simply a SELECT query within a SELECT query
3) ANY evaluates to true if the result of an inner query contains at least one row that satisfies the comparison
4) Correlated subquery
5) Correlated subquery using Distinct
6) Correlated subquery using the department table in both inner and outer queries
7) EXISTS evaluates to true if its result contains at least one row
8) EXISTS Function and Subqueries
9) Leaf-Level Employees (Employees with No Subordinates), Correlated Subquery Syntax
10) Leaf-Level Employees (Employees with No Subordinates), Join Syntax
11) Nested three level subquery with IN operator
12) NOT EXISTS()
13) Return a single value from subquery
14) Reversing the logic using the NOT IN operator
15) RTRIM
16) RTRIM(city),30)
17) Subqueries and ALL operator
18) Subqueries and ANY operator
19) Subqueries and Comparison Operators
20) Subqueries and IN Operator
21) Subqueries can be nested
22) Use aggregate function in subquery
23) Use aggregate function MAX in subquery
24) Use IN operator for a single value
25) Using a Nested Subquery
26) Using the EXISTS() Function
27) Using the IN() Function for subquery
28) WHERE clause in the subquerys SELECT statement links the inner query to the outer query
29) Write a query as part of the FROM clause